--
-- Description: View for displaying the list of products.
-- Date created: 6 May 2008
--

set ANSI_NULLS on
set QUOTED_IDENTIFIER on
go

--
-- drop the view if it exists and recreate it.
--
if exists
(
	select * 
	from sys.views
	where object_id = OBJECT_ID(N'[dbo].[Products_vw]')
)
begin
	drop view [dbo].[Products_vw]
end
go

create view [dbo].[Products_vw] 
as
    select 
    [ProductID]
    , [ProductName]
    , [ProductVersion]
    , [DateCreated]
    , [DateModified]
    , [TotalEvents]
    from [dbo].[Products] (nolock)
go
